home *** CD-ROM | disk | FTP | other *** search
/ EnigmA Amiga Run 1996 June / EnigmA AMIGA RUN 08 (1996)(G.R. Edizioni)(IT)[!][issue 1996-06][EARSAN CD VII].iso / earcd / utmisc1 / esclc20f.lha / Examples / EXAMPLE.calc (.txt) < prev    next >
EasyCalc Spreadsheet file  |  1996-03-31  |  3KB  |  104 lines
  1. EASY30HED1
  2. #'EasyCalc 2.0 - Example Worksheet 2
  3. 'Other EasyCalc functions:
  4. 'Function Example
  5. "Result
  6. '=@ASIN(0.1)
  7. =@ASIN(0.1)
  8. '=@ATAN(0.1)
  9. =@ATAN(0.1)
  10. !'=@AVG(B6:B9) OR =@AVERAGE(B6:B9)
  11. =@AVG(B6:B9)
  12. '=@CINT(1.4)
  13. =@CINT(1.4)
  14. '=@COLS(A1:C1)
  15. =@COLS(A1:C1)
  16. '=@ABS(-50)
  17. =@ABS(-50)
  18. '=@ACOS(0.1)
  19. =@ACOS(0.1)
  20. '=@COS(0.7)
  21. =@COS(0.7)
  22. '=@COSH(0.7)
  23. =@COSH(0.7)
  24. '=@COUNT(A6:B14)
  25. =@COUNT(A6:B14)
  26. '=@DATE(95,3,2)
  27. =@DATE(95,3,2)
  28.     '=@EXP(3)
  29. =@EXP(3)
  30. '=@FALSE
  31. =@FALSE
  32. '=@FIX(1.7)
  33. =@FIX(1.7)
  34. %'=@IF(B18=@FALSE, "NOT TRUE", "TRUE")
  35. $=@IF(B18=@FALSE, "NOT TRUE", "TRUE")
  36. '=@INDEX(A13:B18,1,0)
  37. =@INDEX(A13:B18,1,0)
  38. '=@INT(1.7)
  39. =@INT(1.7)
  40. '=@ISNUM(B18)
  41. =@ISNUM(B18)
  42. '=@ISSTR(B18)
  43. =@ISSTR(B18)
  44. '=@LINK("STRINGS.CALC>B10")
  45. =@LINK("STRINGS.CALC>B14")
  46. '<- Press HELP
  47. '=@LOG10(5)
  48. =@LOG10(5)
  49.     '=@LOG(2)
  50. =@LOG(2)
  51. '=@MAX(B21:B27)
  52. =@MAX(B21:B27)
  53. '=@MIN(B21:B27)
  54. =@MIN(B21:B27)
  55. '=@MOD(10,3)
  56. =@MOD(10,3)
  57. '=@NEWVAT(100,1)
  58. =@NEWVAT(100,1)
  59.     '=@NOT(1)
  60. =@NOT(1)
  61. '=@NOW
  62. =@NOW
  63. '=@PI
  64. '=@RAD(90)
  65.     =@RAD(90)
  66. '=@DEG(1.5707)
  67. =@DEG(1.57079632)
  68. '=@RAND
  69. =@RAND
  70. '=@RND(100)
  71. =@RND(100)
  72. '=@ROWS(A26:B34)
  73. =@ROWS(A26:B34)
  74. '=@SIGN(-56)
  75. =@SIGN(-56)
  76. '=@SIN(0.5)
  77. =@SIN(0.5)
  78. '=@SINH(0.5)
  79. =@SINH(0.5)
  80. '=@SQR(49) OR =@SQRT(49)
  81.     =@SQR(49)
  82. '=@SUM(B34:B43)
  83. =@SUM(B34:B43)
  84. '=@TAN(0.5)
  85. =@TAN(0.5)
  86. '=@TANH(0.5)
  87. =@TANH(0.5)
  88. '=@TIME(16,43,23)
  89. =@TIME(16,43,23)
  90. '=@TODAY
  91. =@TODAY
  92. '=@TRUE
  93. =@TRUE
  94. '=@VAT(100)
  95. =@VAT(100)
  96. '[PRESS HELP HERE]
  97. STRINGS.CALC needs to be loaded for this to evaluate. If the
  98. link worksheet can't be found, then 0 is returned. No error
  99. messages are generated unless the string is invalid.NOTE
  100. To get detailed information on any function displayed here,
  101. press RETURN while over a cell function, then move the
  102. cursor over the '@' symbol of the function you are interested in.
  103. Then press HELP.PALL
  104.